Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 19138 |
| Missing cells | 46006 |
| Missing cells (%) | 10.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 9 |
| Unsupported | 2 |
| Categorical | 7 |
aff_code has constant value "" | Constant |
page_channel has constant value "" | Constant |
fuel_type is highly imbalanced (75.2%) | Imbalance |
msrp has 4686 (24.5%) missing values | Missing |
local_zone has 19138 (100.0%) missing values | Missing |
interior_color has 907 (4.7%) missing values | Missing |
price has 248 (1.3%) missing values | Missing |
price_badge has 19138 (100.0%) missing values | Missing |
trim has 315 (1.6%) missing values | Missing |
mileage has 554 (2.9%) missing values | Missing |
cat has 210 (1.1%) missing values | Missing |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
local_zone is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
price_badge is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
msrp has 3586 (18.7%) zeros | Zeros |
mileage has 708 (3.7%) zeros | Zeros |
Reproduction
| Analysis started | 2024-04-25 00:20:47.837227 |
|---|---|
| Analysis finished | 2024-04-25 00:20:55.109472 |
| Duration | 7.27 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 19138 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9568.5 |
| Minimum | 0 |
|---|---|
| Maximum | 19137 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 956.85 |
| Q1 | 4784.25 |
| median | 9568.5 |
| Q3 | 14352.75 |
| 95-th percentile | 18180.15 |
| Maximum | 19137 |
| Range | 19137 |
| Interquartile range (IQR) | 9568.5 |
Descriptive statistics
| Standard deviation | 5524.8091 |
|---|---|
| Coefficient of variation (CV) | 0.57739552 |
| Kurtosis | -1.2 |
| Mean | 9568.5 |
| Median Absolute Deviation (MAD) | 4784.5 |
| Skewness | 0 |
| Sum | 1.8312195 × 108 |
| Variance | 30523515 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 12764 | 1 | < 0.1% |
| 12762 | 1 | < 0.1% |
| 12761 | 1 | < 0.1% |
| 12760 | 1 | < 0.1% |
| 12759 | 1 | < 0.1% |
| 12758 | 1 | < 0.1% |
| 12757 | 1 | < 0.1% |
| 12756 | 1 | < 0.1% |
| 12755 | 1 | < 0.1% |
| Other values (19128) | 19128 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 19137 | 1 | |
| 19136 | 1 | |
| 19135 | 1 | |
| 19134 | 1 | |
| 19133 | 1 | |
| 19132 | 1 | |
| 19131 | 1 | |
| 19130 | 1 | |
| 19129 | 1 | |
| 19128 | 1 |
msrp
Real number (ℝ)
MISSING ZEROS
| Distinct | 3520 |
|---|---|
| Distinct (%) | 24.4% |
| Missing | 4686 |
| Missing (%) | 24.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38825.187 |
| Minimum | 0 |
|---|---|
| Maximum | 329486 |
| Zeros | 3586 |
| Zeros (%) | 18.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 14940 |
| median | 36748 |
| Q3 | 54595 |
| 95-th percentile | 94105.15 |
| Maximum | 329486 |
| Range | 329486 |
| Interquartile range (IQR) | 39655 |
Descriptive statistics
| Standard deviation | 32152.783 |
|---|---|
| Coefficient of variation (CV) | 0.82814239 |
| Kurtosis | 6.2152576 |
| Mean | 38825.187 |
| Median Absolute Deviation (MAD) | 17847 |
| Skewness | 1.4056051 |
| Sum | 5.6110161 × 108 |
| Variance | 1.0338015 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3586 | 18.7% |
| 36926 | 100 | 0.5% |
| 46465 | 84 | 0.4% |
| 44115 | 81 | 0.4% |
| 54595 | 67 | 0.4% |
| 26980 | 61 | 0.3% |
| 33160 | 58 | 0.3% |
| 38726 | 52 | 0.3% |
| 25080 | 46 | 0.2% |
| 35980 | 46 | 0.2% |
| Other values (3510) | 10271 | |
| (Missing) | 4686 |
| Value | Count | Frequency (%) |
| 0 | 3586 | |
| 6000 | 2 | < 0.1% |
| 7705 | 2 | < 0.1% |
| 7985 | 2 | < 0.1% |
| 9000 | 2 | < 0.1% |
| 9139 | 2 | < 0.1% |
| 9985 | 2 | < 0.1% |
| 10985 | 2 | < 0.1% |
| 10995 | 2 | < 0.1% |
| 11991 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 329486 | 2 | |
| 317486 | 2 | |
| 311895 | 2 | |
| 298875 | 2 | |
| 288300 | 2 | |
| 287400 | 1 | |
| 270710 | 1 | |
| 251160 | 2 | |
| 249320 | 1 | |
| 239600 | 2 |
year
Real number (ℝ)
| Distinct | 57 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2020.7547 |
| Minimum | 1936 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 1936 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2020 |
| median | 2024 |
| Q3 | 2024 |
| 95-th percentile | 2024 |
| Maximum | 2025 |
| Range | 89 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.0393611 |
|---|---|
| Coefficient of variation (CV) | 0.0029886661 |
| Kurtosis | 24.261979 |
| Mean | 2020.7547 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -3.7811783 |
| Sum | 38673204 |
| Variance | 36.473883 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2024 | 9927 | |
| 2023 | 1586 | 8.3% |
| 2021 | 1327 | 6.9% |
| 2020 | 795 | 4.2% |
| 2022 | 709 | 3.7% |
| 2018 | 605 | 3.2% |
| 2019 | 568 | 3.0% |
| 2017 | 510 | 2.7% |
| 2016 | 446 | 2.3% |
| 2015 | 369 | 1.9% |
| Other values (47) | 2296 | 12.0% |
| Value | Count | Frequency (%) |
| 1936 | 2 | < 0.1% |
| 1957 | 8 | |
| 1959 | 2 | < 0.1% |
| 1960 | 2 | < 0.1% |
| 1964 | 2 | < 0.1% |
| 1965 | 7 | |
| 1967 | 2 | < 0.1% |
| 1969 | 2 | < 0.1% |
| 1970 | 2 | < 0.1% |
| 1972 | 8 |
| Value | Count | Frequency (%) |
| 2025 | 198 | 1.0% |
| 2024 | 9927 | |
| 2023 | 1586 | 8.3% |
| 2022 | 709 | 3.7% |
| 2021 | 1327 | 6.9% |
| 2020 | 795 | 4.2% |
| 2019 | 568 | 3.0% |
| 2018 | 605 | 3.2% |
| 2017 | 510 | 2.7% |
| 2016 | 446 | 2.3% |
canonical_mmty
Text
| Distinct | 4070 |
|---|---|
| Distinct (%) | 21.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 102 |
|---|---|
| Median length | 88 |
| Mean length | 28.547393 |
| Min length | 12 |
Characters and Unicode
| Total characters | 546340 |
|---|---|
| Distinct characters | 79 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 280 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | Chevrolet:Blazer EV:RS:2024 |
|---|---|
| 2nd row | RAM:ProMaster 2500:High Roof:2024 |
| 3rd row | Mercedes-Benz:Sprinter 2500:High Roof:2024 |
| 4th row | Honda:CR-V:EX:2024 |
| 5th row | Chevrolet:Equinox:LS:2024 |
| Value | Count | Frequency (%) |
| volkswagen:tiguan:2.0t | 921 | 2.5% |
| se:2024 | 609 | 1.6% |
| ford:bronco | 457 | 1.2% |
| r-line | 338 | 0.9% |
| chevrolet:silverado | 335 | 0.9% |
| gmc:sierra | 328 | 0.9% |
| black:2024 | 310 | 0.8% |
| mercedes-benz:amg | 304 | 0.8% |
| se | 296 | 0.8% |
| jeep:grand | 282 | 0.8% |
| Other values (4559) | 33321 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 57414 | 10.5% |
| 2 | 37963 | 6.9% |
| e | 34880 | 6.4% |
| 0 | 29323 | 5.4% |
| a | 26129 | 4.8% |
| r | 25688 | 4.7% |
| o | 20544 | 3.8% |
| i | 19043 | 3.5% |
| 18343 | 3.4% | |
| n | 16268 | 3.0% |
| Other values (69) | 260745 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 546340 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 57414 | 10.5% |
| 2 | 37963 | 6.9% |
| e | 34880 | 6.4% |
| 0 | 29323 | 5.4% |
| a | 26129 | 4.8% |
| r | 25688 | 4.7% |
| o | 20544 | 3.8% |
| i | 19043 | 3.5% |
| 18343 | 3.4% | |
| n | 16268 | 3.0% |
| Other values (69) | 260745 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 546340 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 57414 | 10.5% |
| 2 | 37963 | 6.9% |
| e | 34880 | 6.4% |
| 0 | 29323 | 5.4% |
| a | 26129 | 4.8% |
| r | 25688 | 4.7% |
| o | 20544 | 3.8% |
| i | 19043 | 3.5% |
| 18343 | 3.4% | |
| n | 16268 | 3.0% |
| Other values (69) | 260745 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 546340 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 57414 | 10.5% |
| 2 | 37963 | 6.9% |
| e | 34880 | 6.4% |
| 0 | 29323 | 5.4% |
| a | 26129 | 4.8% |
| r | 25688 | 4.7% |
| o | 20544 | 3.8% |
| i | 19043 | 3.5% |
| 18343 | 3.4% | |
| n | 16268 | 3.0% |
| Other values (69) | 260745 |
model
Text
| Distinct | 855 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 24 |
| Mean length | 7.3020692 |
| Min length | 1 |
Characters and Unicode
| Total characters | 139747 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 18 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Blazer EV |
|---|---|
| 2nd row | ProMaster 2500 |
| 3rd row | Sprinter 2500 |
| 4th row | CR-V |
| 5th row | Equinox |
| Value | Count | Frequency (%) |
| tiguan | 923 | 3.6% |
| escape | 679 | 2.6% |
| 2500 | 667 | 2.6% |
| sport | 608 | 2.4% |
| 1500 | 580 | 2.2% |
| trax | 523 | 2.0% |
| bronco | 480 | 1.9% |
| hornet | 410 | 1.6% |
| xt5 | 389 | 1.5% |
| equinox | 373 | 1.4% |
| Other values (738) | 20188 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 11236 | 8.0% |
| r | 10231 | 7.3% |
| e | 8894 | 6.4% |
| o | 6888 | 4.9% |
| 6682 | 4.8% | |
| n | 6413 | 4.6% |
| 0 | 5531 | 4.0% |
| i | 5319 | 3.8% |
| t | 5265 | 3.8% |
| s | 4512 | 3.2% |
| Other values (60) | 68776 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 139747 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 11236 | 8.0% |
| r | 10231 | 7.3% |
| e | 8894 | 6.4% |
| o | 6888 | 4.9% |
| 6682 | 4.8% | |
| n | 6413 | 4.6% |
| 0 | 5531 | 4.0% |
| i | 5319 | 3.8% |
| t | 5265 | 3.8% |
| s | 4512 | 3.2% |
| Other values (60) | 68776 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 139747 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 11236 | 8.0% |
| r | 10231 | 7.3% |
| e | 8894 | 6.4% |
| o | 6888 | 4.9% |
| 6682 | 4.8% | |
| n | 6413 | 4.6% |
| 0 | 5531 | 4.0% |
| i | 5319 | 3.8% |
| t | 5265 | 3.8% |
| s | 4512 | 3.2% |
| Other values (60) | 68776 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 139747 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 11236 | 8.0% |
| r | 10231 | 7.3% |
| e | 8894 | 6.4% |
| o | 6888 | 4.9% |
| 6682 | 4.8% | |
| n | 6413 | 4.6% |
| 0 | 5531 | 4.0% |
| i | 5319 | 3.8% |
| t | 5265 | 3.8% |
| s | 4512 | 3.2% |
| Other values (60) | 68776 |
local_zone
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 19138 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 149.6 KiB |
interior_color
Text
MISSING
| Distinct | 710 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 907 |
| Missing (%) | 4.7% |
| Memory size | 149.6 KiB |
Length
| Max length | 47 |
|---|---|
| Median length | 43 |
| Mean length | 7.9224947 |
| Min length | 2 |
Characters and Unicode
| Total characters | 144435 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 42 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Black |
|---|---|
| 2nd row | Black |
| 3rd row | Gray |
| 4th row | Medium Ash Gray |
| 5th row | Pearl Beige |
| Value | Count | Frequency (%) |
| black | 10216 | |
| jet | 1785 | 6.7% |
| gray | 1760 | 6.6% |
| ebony | 1531 | 5.7% |
| charcoal | 739 | 2.8% |
| beige | 483 | 1.8% |
| medium | 474 | 1.8% |
| red | 454 | 1.7% |
| 444 | 1.7% | |
| onyx | 411 | 1.5% |
| Other values (525) | 8460 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 18289 | |
| l | 12824 | 8.9% |
| c | 12696 | 8.8% |
| B | 11820 | 8.2% |
| k | 11107 | 7.7% |
| 8540 | 5.9% | |
| e | 8195 | 5.7% |
| r | 5926 | 4.1% |
| t | 5283 | 3.7% |
| n | 5159 | 3.6% |
| Other values (57) | 44596 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144435 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 18289 | |
| l | 12824 | 8.9% |
| c | 12696 | 8.8% |
| B | 11820 | 8.2% |
| k | 11107 | 7.7% |
| 8540 | 5.9% | |
| e | 8195 | 5.7% |
| r | 5926 | 4.1% |
| t | 5283 | 3.7% |
| n | 5159 | 3.6% |
| Other values (57) | 44596 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144435 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 18289 | |
| l | 12824 | 8.9% |
| c | 12696 | 8.8% |
| B | 11820 | 8.2% |
| k | 11107 | 7.7% |
| 8540 | 5.9% | |
| e | 8195 | 5.7% |
| r | 5926 | 4.1% |
| t | 5283 | 3.7% |
| n | 5159 | 3.6% |
| Other values (57) | 44596 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144435 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 18289 | |
| l | 12824 | 8.9% |
| c | 12696 | 8.8% |
| B | 11820 | 8.2% |
| k | 11107 | 7.7% |
| 8540 | 5.9% | |
| e | 8195 | 5.7% |
| r | 5926 | 4.1% |
| t | 5283 | 3.7% |
| n | 5159 | 3.6% |
| Other values (57) | 44596 |
aff_code
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
| national |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 153104 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | national |
|---|---|
| 2nd row | national |
| 3rd row | national |
| 4th row | national |
| 5th row | national |
Common Values
| Value | Count | Frequency (%) |
| national | 19138 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| national | 19138 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 38276 | |
| a | 38276 | |
| t | 19138 | |
| i | 19138 | |
| o | 19138 | |
| l | 19138 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 38276 | |
| a | 38276 | |
| t | 19138 | |
| i | 19138 | |
| o | 19138 | |
| l | 19138 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 38276 | |
| a | 38276 | |
| t | 19138 | |
| i | 19138 | |
| o | 19138 | |
| l | 19138 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 38276 | |
| a | 38276 | |
| t | 19138 | |
| i | 19138 | |
| o | 19138 | |
| l | 19138 |
price
Real number (ℝ)
MISSING
| Distinct | 6415 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 248 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43913.221 |
| Minimum | 0 |
|---|---|
| Maximum | 1699800 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10980 |
| Q1 | 25335 |
| median | 35003 |
| Q3 | 51873 |
| 95-th percentile | 97145 |
| Maximum | 1699800 |
| Range | 1699800 |
| Interquartile range (IQR) | 26538 |
Descriptive statistics
| Standard deviation | 41443.429 |
|---|---|
| Coefficient of variation (CV) | 0.94375744 |
| Kurtosis | 311.22747 |
| Mean | 43913.221 |
| Median Absolute Deviation (MAD) | 12513 |
| Skewness | 11.133983 |
| Sum | 8.2952075 × 108 |
| Variance | 1.7175578 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 49115 | 85 | 0.4% |
| 51465 | 82 | 0.4% |
| 33504 | 62 | 0.3% |
| 9995 | 53 | 0.3% |
| 26980 | 52 | 0.3% |
| 16995 | 50 | 0.3% |
| 23885 | 46 | 0.2% |
| 15995 | 46 | 0.2% |
| 18995 | 45 | 0.2% |
| 19995 | 44 | 0.2% |
| Other values (6405) | 18325 | |
| (Missing) | 248 | 1.3% |
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 32 | 1 | < 0.1% |
| 1500 | 2 | |
| 1700 | 2 | |
| 2000 | 2 | |
| 2900 | 2 | |
| 2990 | 2 | |
| 3000 | 2 | |
| 3350 | 2 | |
| 3440 | 2 |
| Value | Count | Frequency (%) |
| 1699800 | 2 | |
| 829800 | 1 | |
| 709800 | 2 | |
| 639800 | 2 | |
| 579999 | 1 | |
| 569895 | 2 | |
| 569800 | 2 | |
| 519900 | 2 | |
| 489800 | 2 | |
| 459999 | 2 |
price_badge
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 19138 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 149.6 KiB |
trim
Text
MISSING
| Distinct | 1159 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 315 |
| Missing (%) | 1.6% |
| Memory size | 149.6 KiB |
Length
| Max length | 75 |
|---|---|
| Median length | 65 |
| Mean length | 8.0118472 |
| Min length | 1 |
Characters and Unicode
| Total characters | 150807 |
|---|---|
| Distinct characters | 78 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 57 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | RS |
|---|---|
| 2nd row | High Roof |
| 3rd row | High Roof |
| 4th row | EX |
| 5th row | LS |
| Value | Count | Frequency (%) |
| base | 1563 | 5.2% |
| premium | 1330 | 4.4% |
| se | 1214 | 4.0% |
| 2.0t | 1164 | 3.8% |
| s | 777 | 2.6% |
| limited | 728 | 2.4% |
| 4matic | 616 | 2.0% |
| sport | 547 | 1.8% |
| luxury | 545 | 1.8% |
| sel | 540 | 1.8% |
| Other values (831) | 21278 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12739 | 8.4% |
| 11459 | 7.6% | |
| i | 9303 | 6.2% |
| r | 7663 | 5.1% |
| T | 6394 | 4.2% |
| S | 6230 | 4.1% |
| a | 6137 | 4.1% |
| L | 5872 | 3.9% |
| u | 4771 | 3.2% |
| m | 4438 | 2.9% |
| Other values (68) | 75801 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 150807 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 12739 | 8.4% |
| 11459 | 7.6% | |
| i | 9303 | 6.2% |
| r | 7663 | 5.1% |
| T | 6394 | 4.2% |
| S | 6230 | 4.1% |
| a | 6137 | 4.1% |
| L | 5872 | 3.9% |
| u | 4771 | 3.2% |
| m | 4438 | 2.9% |
| Other values (68) | 75801 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 150807 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 12739 | 8.4% |
| 11459 | 7.6% | |
| i | 9303 | 6.2% |
| r | 7663 | 5.1% |
| T | 6394 | 4.2% |
| S | 6230 | 4.1% |
| a | 6137 | 4.1% |
| L | 5872 | 3.9% |
| u | 4771 | 3.2% |
| m | 4438 | 2.9% |
| Other values (68) | 75801 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 150807 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 12739 | 8.4% |
| 11459 | 7.6% | |
| i | 9303 | 6.2% |
| r | 7663 | 5.1% |
| T | 6394 | 4.2% |
| S | 6230 | 4.1% |
| a | 6137 | 4.1% |
| L | 5872 | 3.9% |
| u | 4771 | 3.2% |
| m | 4438 | 2.9% |
| Other values (68) | 75801 |
drivetrain
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 103 |
| Missing (%) | 0.5% |
| Memory size | 149.6 KiB |
| All-wheel Drive | |
|---|---|
| Front-wheel Drive | |
| Four-wheel Drive | |
| Rear-wheel Drive | |
| AWD | 548 |
| Other values (4) | 361 |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 15.098765 |
| Min length | 3 |
Characters and Unicode
| Total characters | 287405 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | All-wheel Drive |
|---|---|
| 2nd row | Front-wheel Drive |
| 3rd row | Rear-wheel Drive |
| 4th row | Front-wheel Drive |
| 5th row | Front-wheel Drive |
Common Values
| Value | Count | Frequency (%) |
| All-wheel Drive | 9212 | |
| Front-wheel Drive | 3726 | |
| Four-wheel Drive | 3245 | 17.0% |
| Rear-wheel Drive | 1943 | 10.2% |
| AWD | 548 | 2.9% |
| FWD | 190 | 1.0% |
| 4WD | 103 | 0.5% |
| Unknown | 37 | 0.2% |
| RWD | 31 | 0.2% |
| (Missing) | 103 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| drive | 18126 | |
| all-wheel | 9212 | |
| front-wheel | 3726 | 10.0% |
| four-wheel | 3245 | 8.7% |
| rear-wheel | 1943 | 5.2% |
| awd | 548 | 1.5% |
| fwd | 190 | 0.5% |
| 4wd | 103 | 0.3% |
| unknown | 37 | 0.1% |
| rwd | 31 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 56321 | |
| l | 36550 | |
| r | 27040 | |
| D | 18998 | 6.6% |
| w | 18163 | 6.3% |
| - | 18126 | 6.3% |
| h | 18126 | 6.3% |
| 18126 | 6.3% | |
| i | 18126 | 6.3% |
| v | 18126 | 6.3% |
| Other values (12) | 39703 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 287405 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 56321 | |
| l | 36550 | |
| r | 27040 | |
| D | 18998 | 6.6% |
| w | 18163 | 6.3% |
| - | 18126 | 6.3% |
| h | 18126 | 6.3% |
| 18126 | 6.3% | |
| i | 18126 | 6.3% |
| v | 18126 | 6.3% |
| Other values (12) | 39703 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 287405 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 56321 | |
| l | 36550 | |
| r | 27040 | |
| D | 18998 | 6.6% |
| w | 18163 | 6.3% |
| - | 18126 | 6.3% |
| h | 18126 | 6.3% |
| 18126 | 6.3% | |
| i | 18126 | 6.3% |
| v | 18126 | 6.3% |
| Other values (12) | 39703 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 287405 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 56321 | |
| l | 36550 | |
| r | 27040 | |
| D | 18998 | 6.6% |
| w | 18163 | 6.3% |
| - | 18126 | 6.3% |
| h | 18126 | 6.3% |
| 18126 | 6.3% | |
| i | 18126 | 6.3% |
| v | 18126 | 6.3% |
| Other values (12) | 39703 |
dealer_name
Text
| Distinct | 427 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 154 |
| Missing (%) | 0.8% |
| Memory size | 149.6 KiB |
Length
| Max length | 86 |
|---|---|
| Median length | 49 |
| Mean length | 24.086705 |
| Min length | 6 |
Characters and Unicode
| Total characters | 457262 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Castle Rock Chevrolet GMC |
|---|---|
| 2nd row | New Smyrna Chrysler Jeep Dodge RAM |
| 3rd row | Mercedes-Benz of Farmington |
| 4th row | Kingman Honda |
| 5th row | McSweeney Chevrolet GMC Clanton |
| Value | Count | Frequency (%) |
| of | 6083 | 8.7% |
| ford | 2351 | 3.3% |
| chevrolet | 1748 | 2.5% |
| chicago | 1698 | 2.4% |
| auto | 1468 | 2.1% |
| dodge | 1323 | 1.9% |
| ram | 1292 | 1.8% |
| jeep | 1292 | 1.8% |
| chrysler | 1292 | 1.8% |
| volkswagen | 1183 | 1.7% |
| Other values (416) | 50490 |
Most occurring characters
| Value | Count | Frequency (%) |
| 51236 | 11.2% | |
| o | 37705 | 8.2% |
| e | 35522 | 7.8% |
| a | 30049 | 6.6% |
| r | 27812 | 6.1% |
| l | 22164 | 4.8% |
| n | 20319 | 4.4% |
| i | 19173 | 4.2% |
| t | 18921 | 4.1% |
| s | 17122 | 3.7% |
| Other values (57) | 177239 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 457262 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 51236 | 11.2% | |
| o | 37705 | 8.2% |
| e | 35522 | 7.8% |
| a | 30049 | 6.6% |
| r | 27812 | 6.1% |
| l | 22164 | 4.8% |
| n | 20319 | 4.4% |
| i | 19173 | 4.2% |
| t | 18921 | 4.1% |
| s | 17122 | 3.7% |
| Other values (57) | 177239 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 457262 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 51236 | 11.2% | |
| o | 37705 | 8.2% |
| e | 35522 | 7.8% |
| a | 30049 | 6.6% |
| r | 27812 | 6.1% |
| l | 22164 | 4.8% |
| n | 20319 | 4.4% |
| i | 19173 | 4.2% |
| t | 18921 | 4.1% |
| s | 17122 | 3.7% |
| Other values (57) | 177239 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 457262 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 51236 | 11.2% | |
| o | 37705 | 8.2% |
| e | 35522 | 7.8% |
| a | 30049 | 6.6% |
| r | 27812 | 6.1% |
| l | 22164 | 4.8% |
| n | 20319 | 4.4% |
| i | 19173 | 4.2% |
| t | 18921 | 4.1% |
| s | 17122 | 3.7% |
| Other values (57) | 177239 |
dealer_zip
Real number (ℝ)
| Distinct | 141 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 154 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59792.083 |
| Minimum | 11361 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 11361 |
|---|---|
| 5-th percentile | 60004 |
| Q1 | 60126 |
| median | 60445 |
| Q3 | 60540 |
| 95-th percentile | 60647 |
| Maximum | 99301 |
| Range | 87940 |
| Interquartile range (IQR) | 414 |
Descriptive statistics
| Standard deviation | 3049.2189 |
|---|---|
| Coefficient of variation (CV) | 0.050997034 |
| Kurtosis | 34.310769 |
| Mean | 59792.083 |
| Median Absolute Deviation (MAD) | 196 |
| Skewness | -3.9667216 |
| Sum | 1.1350929 × 109 |
| Variance | 9297735.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 60540 | 1343 | 7.0% |
| 60515 | 959 | 5.0% |
| 60525 | 637 | 3.3% |
| 60453 | 593 | 3.1% |
| 46322 | 578 | 3.0% |
| 60126 | 570 | 3.0% |
| 60025 | 469 | 2.5% |
| 60559 | 455 | 2.4% |
| 60035 | 448 | 2.3% |
| 60610 | 416 | 2.2% |
| Other values (131) | 12516 |
| Value | Count | Frequency (%) |
| 11361 | 1 | < 0.1% |
| 17042 | 1 | < 0.1% |
| 20904 | 3 | |
| 26101 | 1 | < 0.1% |
| 30028 | 3 | |
| 30157 | 1 | < 0.1% |
| 31210 | 2 | |
| 32168 | 1 | < 0.1% |
| 34997 | 3 | |
| 35045 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 1 | < 0.1% |
| 95661 | 1 | < 0.1% |
| 94596 | 3 | |
| 89146 | 1 | < 0.1% |
| 86409 | 2 | |
| 86004 | 1 | < 0.1% |
| 84025 | 1 | < 0.1% |
| 82001 | 2 | |
| 80221 | 1 | < 0.1% |
| 80104 | 1 | < 0.1% |
mileage
Real number (ℝ)
MISSING ZEROS
| Distinct | 4624 |
|---|---|
| Distinct (%) | 24.9% |
| Missing | 554 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26047.929 |
| Minimum | 0 |
|---|---|
| Maximum | 440911 |
| Zeros | 708 |
| Zeros (%) | 3.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 27 |
| Q3 | 41725 |
| 95-th percentile | 113174.25 |
| Maximum | 440911 |
| Range | 440911 |
| Interquartile range (IQR) | 41720 |
Descriptive statistics
| Standard deviation | 41874.321 |
|---|---|
| Coefficient of variation (CV) | 1.6075874 |
| Kurtosis | 6.1633143 |
| Mean | 26047.929 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 2.1076472 |
| Sum | 4.8407471 × 108 |
| Variance | 1.7534588 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10 | 1317 | 6.9% |
| 5 | 1292 | 6.8% |
| 3 | 1020 | 5.3% |
| 0 | 708 | 3.7% |
| 6 | 668 | 3.5% |
| 2 | 662 | 3.5% |
| 1 | 559 | 2.9% |
| 7 | 536 | 2.8% |
| 4 | 469 | 2.5% |
| 11 | 360 | 1.9% |
| Other values (4614) | 10993 | |
| (Missing) | 554 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 708 | |
| 1 | 559 | |
| 2 | 662 | |
| 3 | 1020 | |
| 4 | 469 | 2.5% |
| 5 | 1292 | |
| 6 | 668 | |
| 7 | 536 | |
| 8 | 325 | 1.7% |
| 9 | 243 | 1.3% |
| Value | Count | Frequency (%) |
| 440911 | 2 | |
| 426586 | 2 | |
| 385223 | 2 | |
| 350017 | 2 | |
| 317568 | 2 | |
| 304425 | 2 | |
| 274023 | 2 | |
| 268470 | 1 | |
| 265649 | 2 | |
| 241421 | 2 |
make
Text
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 6.3653464 |
| Min length | 3 |
Characters and Unicode
| Total characters | 121820 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Chevrolet |
|---|---|
| 2nd row | RAM |
| 3rd row | Mercedes-Benz |
| 4th row | Honda |
| 5th row | Chevrolet |
| Value | Count | Frequency (%) |
| ford | 2587 | 13.4% |
| chevrolet | 2059 | 10.6% |
| volkswagen | 1541 | 8.0% |
| bmw | 1298 | 6.7% |
| mercedes-benz | 1065 | 5.5% |
| subaru | 808 | 4.2% |
| cadillac | 805 | 4.2% |
| nissan | 803 | 4.2% |
| jeep | 674 | 3.5% |
| dodge | 658 | 3.4% |
| Other values (54) | 7042 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13247 | 10.9% |
| o | 10018 | 8.2% |
| a | 8756 | 7.2% |
| r | 7794 | 6.4% |
| d | 7277 | 6.0% |
| l | 6352 | 5.2% |
| n | 5858 | 4.8% |
| s | 5325 | 4.4% |
| i | 4421 | 3.6% |
| M | 3952 | 3.2% |
| Other values (36) | 48820 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 121820 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 13247 | 10.9% |
| o | 10018 | 8.2% |
| a | 8756 | 7.2% |
| r | 7794 | 6.4% |
| d | 7277 | 6.0% |
| l | 6352 | 5.2% |
| n | 5858 | 4.8% |
| s | 5325 | 4.4% |
| i | 4421 | 3.6% |
| M | 3952 | 3.2% |
| Other values (36) | 48820 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 121820 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 13247 | 10.9% |
| o | 10018 | 8.2% |
| a | 8756 | 7.2% |
| r | 7794 | 6.4% |
| d | 7277 | 6.0% |
| l | 6352 | 5.2% |
| n | 5858 | 4.8% |
| s | 5325 | 4.4% |
| i | 4421 | 3.6% |
| M | 3952 | 3.2% |
| Other values (36) | 48820 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 121820 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 13247 | 10.9% |
| o | 10018 | 8.2% |
| a | 8756 | 7.2% |
| r | 7794 | 6.4% |
| d | 7277 | 6.0% |
| l | 6352 | 5.2% |
| n | 5858 | 4.8% |
| s | 5325 | 4.4% |
| i | 4421 | 3.6% |
| M | 3952 | 3.2% |
| Other values (36) | 48820 |
bodystyle
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 100 |
| Missing (%) | 0.5% |
| Memory size | 149.6 KiB |
| SUV | |
|---|---|
| Sedan | |
| Pickup Truck | |
| Coupe | 756 |
| Cargo Van | 727 |
| Other values (5) |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 4.9319781 |
| Min length | 3 |
Characters and Unicode
| Total characters | 93895 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SUV |
|---|---|
| 2nd row | Cargo Van |
| 3rd row | Cargo Van |
| 4th row | SUV |
| 5th row | SUV |
Common Values
| Value | Count | Frequency (%) |
| SUV | 11293 | |
| Sedan | 3121 | 16.3% |
| Pickup Truck | 1625 | 8.5% |
| Coupe | 756 | 4.0% |
| Cargo Van | 727 | 3.8% |
| Convertible | 603 | 3.2% |
| Hatchback | 531 | 2.8% |
| Wagon | 202 | 1.1% |
| Passenger Van | 151 | 0.8% |
| Minivan | 29 | 0.2% |
| (Missing) | 100 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| suv | 11293 | |
| sedan | 3121 | 14.5% |
| pickup | 1625 | 7.5% |
| truck | 1625 | 7.5% |
| van | 878 | 4.1% |
| coupe | 756 | 3.5% |
| cargo | 727 | 3.4% |
| convertible | 603 | 2.8% |
| hatchback | 531 | 2.5% |
| wagon | 202 | 0.9% |
| Other values (2) | 180 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 14414 | |
| V | 12171 | |
| U | 11293 | |
| a | 6170 | 6.6% |
| e | 5385 | 5.7% |
| n | 5013 | 5.3% |
| c | 4312 | 4.6% |
| u | 4006 | 4.3% |
| k | 3781 | 4.0% |
| d | 3121 | 3.3% |
| Other values (18) | 24229 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 93895 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 14414 | |
| V | 12171 | |
| U | 11293 | |
| a | 6170 | 6.6% |
| e | 5385 | 5.7% |
| n | 5013 | 5.3% |
| c | 4312 | 4.6% |
| u | 4006 | 4.3% |
| k | 3781 | 4.0% |
| d | 3121 | 3.3% |
| Other values (18) | 24229 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 93895 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 14414 | |
| V | 12171 | |
| U | 11293 | |
| a | 6170 | 6.6% |
| e | 5385 | 5.7% |
| n | 5013 | 5.3% |
| c | 4312 | 4.6% |
| u | 4006 | 4.3% |
| k | 3781 | 4.0% |
| d | 3121 | 3.3% |
| Other values (18) | 24229 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 93895 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 14414 | |
| V | 12171 | |
| U | 11293 | |
| a | 6170 | 6.6% |
| e | 5385 | 5.7% |
| n | 5013 | 5.3% |
| c | 4312 | 4.6% |
| u | 4006 | 4.3% |
| k | 3781 | 4.0% |
| d | 3121 | 3.3% |
| Other values (18) | 24229 |
cat
Categorical
MISSING
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 210 |
| Missing (%) | 1.1% |
| Memory size | 149.6 KiB |
| crossover_compact | |
|---|---|
| luxurysuv_crossover | |
| crossover_midsize | |
| truck_fullsize | |
| suv_midsize | |
| Other values (32) |
Length
| Max length | 28 |
|---|---|
| Median length | 24 |
| Mean length | 16.529533 |
| Min length | 8 |
Characters and Unicode
| Total characters | 312871 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ev_crossover_midsize |
|---|---|
| 2nd row | van_fullsize |
| 3rd row | van_fullsize |
| 4th row | crossover_compact |
| 5th row | crossover_midsize |
Common Values
| Value | Count | Frequency (%) |
| crossover_compact | 4192 | |
| luxurysuv_crossover | 2226 | |
| crossover_midsize | 1334 | 7.0% |
| truck_fullsize | 1226 | 6.4% |
| suv_midsize | 990 | 5.2% |
| luxurypassenger_standard | 929 | 4.9% |
| hybrid_suv | 919 | 4.8% |
| van_fullsize | 818 | 4.3% |
| sedan_compact | 815 | 4.3% |
| luxurypassenger_plus | 787 | 4.1% |
| Other values (27) | 4692 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| crossover_compact | 4192 | |
| luxurysuv_crossover | 2226 | |
| crossover_midsize | 1334 | 7.0% |
| truck_fullsize | 1226 | 6.5% |
| suv_midsize | 990 | 5.2% |
| luxurypassenger_standard | 929 | 4.9% |
| hybrid_suv | 919 | 4.9% |
| van_fullsize | 818 | 4.3% |
| sedan_compact | 815 | 4.3% |
| luxurypassenger_plus | 787 | 4.2% |
| Other values (27) | 4692 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 36790 | |
| r | 28762 | 9.2% |
| o | 24409 | 7.8% |
| e | 24137 | 7.7% |
| c | 24134 | 7.7% |
| u | 22425 | 7.2% |
| _ | 20108 | 6.4% |
| v | 17473 | 5.6% |
| a | 14816 | 4.7% |
| i | 11855 | 3.8% |
| Other values (15) | 87962 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 312871 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 36790 | |
| r | 28762 | 9.2% |
| o | 24409 | 7.8% |
| e | 24137 | 7.7% |
| c | 24134 | 7.7% |
| u | 22425 | 7.2% |
| _ | 20108 | 6.4% |
| v | 17473 | 5.6% |
| a | 14816 | 4.7% |
| i | 11855 | 3.8% |
| Other values (15) | 87962 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 312871 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 36790 | |
| r | 28762 | 9.2% |
| o | 24409 | 7.8% |
| e | 24137 | 7.7% |
| c | 24134 | 7.7% |
| u | 22425 | 7.2% |
| _ | 20108 | 6.4% |
| v | 17473 | 5.6% |
| a | 14816 | 4.7% |
| i | 11855 | 3.8% |
| Other values (15) | 87962 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 312871 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 36790 | |
| r | 28762 | 9.2% |
| o | 24409 | 7.8% |
| e | 24137 | 7.7% |
| c | 24134 | 7.7% |
| u | 22425 | 7.2% |
| _ | 20108 | 6.4% |
| v | 17473 | 5.6% |
| a | 14816 | 4.7% |
| i | 11855 | 3.8% |
| Other values (15) | 87962 |
vin
Text
| Distinct | 10061 |
|---|---|
| Distinct (%) | 52.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.993939 |
| Min length | 10 |
Characters and Unicode
| Total characters | 325230 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 984 ? |
|---|---|
| Unique (%) | 5.1% |
Sample
| 1st row | 3GNKDCRJ6RS227894 |
|---|---|
| 2nd row | 3C6LRVDG0RE118763 |
| 3rd row | W1Y4KCHY8RT178723 |
| 4th row | 5J6RS3H44RL004214 |
| 5th row | 3GNAXHEG1RL299011 |
| Value | Count | Frequency (%) |
| 1fmcu9mn1rua60138 | 2 | < 0.1% |
| 1g6dw677950218907 | 2 | < 0.1% |
| 1g2mg35x07y138075 | 2 | < 0.1% |
| wz1db0c00nw048997 | 2 | < 0.1% |
| w04gr6sx1k1011517 | 2 | < 0.1% |
| jnkay01fx8m653034 | 2 | < 0.1% |
| 1g6dw67v980197947 | 2 | < 0.1% |
| 1g6dc67a250157114 | 2 | < 0.1% |
| zffyr51a9x0116838 | 2 | < 0.1% |
| 1g1bl52pxtr108710 | 2 | < 0.1% |
| Other values (10051) | 19118 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 25562 | 7.9% |
| 3 | 21151 | 6.5% |
| 0 | 19091 | 5.9% |
| 2 | 18453 | 5.7% |
| 4 | 16765 | 5.2% |
| 5 | 16500 | 5.1% |
| 7 | 16102 | 5.0% |
| R | 14817 | 4.6% |
| 6 | 14263 | 4.4% |
| 8 | 13638 | 4.2% |
| Other values (26) | 148888 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 325230 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25562 | 7.9% |
| 3 | 21151 | 6.5% |
| 0 | 19091 | 5.9% |
| 2 | 18453 | 5.7% |
| 4 | 16765 | 5.2% |
| 5 | 16500 | 5.1% |
| 7 | 16102 | 5.0% |
| R | 14817 | 4.6% |
| 6 | 14263 | 4.4% |
| 8 | 13638 | 4.2% |
| Other values (26) | 148888 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 325230 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25562 | 7.9% |
| 3 | 21151 | 6.5% |
| 0 | 19091 | 5.9% |
| 2 | 18453 | 5.7% |
| 4 | 16765 | 5.2% |
| 5 | 16500 | 5.1% |
| 7 | 16102 | 5.0% |
| R | 14817 | 4.6% |
| 6 | 14263 | 4.4% |
| 8 | 13638 | 4.2% |
| Other values (26) | 148888 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 325230 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25562 | 7.9% |
| 3 | 21151 | 6.5% |
| 0 | 19091 | 5.9% |
| 2 | 18453 | 5.7% |
| 4 | 16765 | 5.2% |
| 5 | 16500 | 5.1% |
| 7 | 16102 | 5.0% |
| R | 14817 | 4.6% |
| 6 | 14263 | 4.4% |
| 8 | 13638 | 4.2% |
| Other values (26) | 148888 |
canonical_mmt
Text
| Distinct | 2491 |
|---|---|
| Distinct (%) | 13.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 97 |
|---|---|
| Median length | 83 |
| Mean length | 23.547393 |
| Min length | 7 |
Characters and Unicode
| Total characters | 450650 |
|---|---|
| Distinct characters | 79 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 135 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Chevrolet:Blazer EV:RS |
|---|---|
| 2nd row | RAM:ProMaster 2500:High Roof |
| 3rd row | Mercedes-Benz:Sprinter 2500:High Roof |
| 4th row | Honda:CR-V:EX |
| 5th row | Chevrolet:Equinox:LS |
| Value | Count | Frequency (%) |
| se | 975 | 2.6% |
| volkswagen:tiguan:2.0t | 921 | 2.5% |
| 4matic | 502 | 1.3% |
| plus | 501 | 1.3% |
| s | 491 | 1.3% |
| ford:bronco | 457 | 1.2% |
| premium | 447 | 1.2% |
| r-line | 441 | 1.2% |
| black | 378 | 1.0% |
| chevrolet:silverado | 335 | 0.9% |
| Other values (2542) | 32053 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 38276 | 8.5% |
| e | 34880 | 7.7% |
| a | 26129 | 5.8% |
| r | 25688 | 5.7% |
| o | 20544 | 4.6% |
| i | 19043 | 4.2% |
| 18343 | 4.1% | |
| n | 16268 | 3.6% |
| s | 13528 | 3.0% |
| l | 12588 | 2.8% |
| Other values (69) | 225363 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 450650 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 38276 | 8.5% |
| e | 34880 | 7.7% |
| a | 26129 | 5.8% |
| r | 25688 | 5.7% |
| o | 20544 | 4.6% |
| i | 19043 | 4.2% |
| 18343 | 4.1% | |
| n | 16268 | 3.6% |
| s | 13528 | 3.0% |
| l | 12588 | 2.8% |
| Other values (69) | 225363 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 450650 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 38276 | 8.5% |
| e | 34880 | 7.7% |
| a | 26129 | 5.8% |
| r | 25688 | 5.7% |
| o | 20544 | 4.6% |
| i | 19043 | 4.2% |
| 18343 | 4.1% | |
| n | 16268 | 3.6% |
| s | 13528 | 3.0% |
| l | 12588 | 2.8% |
| Other values (69) | 225363 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 450650 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 38276 | 8.5% |
| e | 34880 | 7.7% |
| a | 26129 | 5.8% |
| r | 25688 | 5.7% |
| o | 20544 | 4.6% |
| i | 19043 | 4.2% |
| 18343 | 4.1% | |
| n | 16268 | 3.6% |
| s | 13528 | 3.0% |
| l | 12588 | 2.8% |
| Other values (69) | 225363 |
fuel_type
Categorical
IMBALANCE
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 129 |
| Missing (%) | 0.7% |
| Memory size | 149.6 KiB |
| Gasoline | |
|---|---|
| Electric | 1199 |
| Hybrid | 1000 |
| Diesel | 397 |
| E85 Flex Fuel | 320 |
| Other values (8) | 35 |
Length
| Max length | 16 |
|---|---|
| Median length | 8 |
| Mean length | 7.9471303 |
| Min length | 6 |
Characters and Unicode
| Total characters | 151067 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Electric |
|---|---|
| 2nd row | Gasoline |
| 3rd row | Diesel |
| 4th row | Gasoline |
| 5th row | Gasoline |
Common Values
| Value | Count | Frequency (%) |
| Gasoline | 16058 | |
| Electric | 1199 | 6.3% |
| Hybrid | 1000 | 5.2% |
| Diesel | 397 | 2.1% |
| E85 Flex Fuel | 320 | 1.7% |
| Flexible Fuel | 11 | 0.1% |
| Plug-In Hybrid | 6 | < 0.1% |
| Bio Diesel | 4 | < 0.1% |
| Plug-in Gas/Elec | 4 | < 0.1% |
| Gasoline Fuel | 4 | < 0.1% |
| Other values (3) | 6 | < 0.1% |
| (Missing) | 129 | 0.7% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| gasoline | 16062 | |
| electric | 1201 | 6.1% |
| hybrid | 1008 | 5.1% |
| diesel | 401 | 2.0% |
| fuel | 337 | 1.7% |
| e85 | 320 | 1.6% |
| flex | 320 | 1.6% |
| flexible | 11 | 0.1% |
| plug-in | 10 | 0.1% |
| bio | 4 | < 0.1% |
| Other values (5) | 12 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 18750 | |
| i | 18695 | |
| l | 18359 | |
| s | 16469 | |
| n | 16072 | |
| G | 16070 | |
| a | 16070 | |
| o | 16066 | |
| c | 2410 | 1.6% |
| r | 2211 | 1.5% |
| Other values (21) | 9895 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 151067 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 18750 | |
| i | 18695 | |
| l | 18359 | |
| s | 16469 | |
| n | 16072 | |
| G | 16070 | |
| a | 16070 | |
| o | 16066 | |
| c | 2410 | 1.6% |
| r | 2211 | 1.5% |
| Other values (21) | 9895 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 151067 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 18750 | |
| i | 18695 | |
| l | 18359 | |
| s | 16469 | |
| n | 16072 | |
| G | 16070 | |
| a | 16070 | |
| o | 16066 | |
| c | 2410 | 1.6% |
| r | 2211 | 1.5% |
| Other values (21) | 9895 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 151067 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 18750 | |
| i | 18695 | |
| l | 18359 | |
| s | 16469 | |
| n | 16072 | |
| G | 16070 | |
| a | 16070 | |
| o | 16066 | |
| c | 2410 | 1.6% |
| r | 2211 | 1.5% |
| Other values (21) | 9895 |
stock_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
| New | |
|---|---|
| Used |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.4469642 |
| Min length | 3 |
Characters and Unicode
| Total characters | 65968 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New |
|---|---|
| 2nd row | New |
| 3rd row | New |
| 4th row | New |
| 5th row | New |
Common Values
| Value | Count | Frequency (%) |
| New | 10584 | |
| Used | 8554 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 10584 | |
| used | 8554 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 19138 | |
| N | 10584 | |
| w | 10584 | |
| U | 8554 | |
| s | 8554 | |
| d | 8554 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65968 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 19138 | |
| N | 10584 | |
| w | 10584 | |
| U | 8554 | |
| s | 8554 | |
| d | 8554 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65968 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 19138 | |
| N | 10584 | |
| w | 10584 | |
| U | 8554 | |
| s | 8554 | |
| d | 8554 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65968 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 19138 | |
| N | 10584 | |
| w | 10584 | |
| U | 8554 | |
| s | 8554 | |
| d | 8554 |
exterior_color
Text
| Distinct | 1321 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 170 |
| Missing (%) | 0.9% |
| Memory size | 149.6 KiB |
Length
| Max length | 48 |
|---|---|
| Median length | 41 |
| Mean length | 15.19127 |
| Min length | 3 |
Characters and Unicode
| Total characters | 288148 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 84 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | sterling_gray_metallic |
|---|---|
| 2nd row | bright_white_clearcoat |
| 3rd row | blue_grey |
| 4th row | radiant_red_metallic |
| 5th row | summit_white |
| Value | Count | Frequency (%) |
| black | 1118 | 5.9% |
| summit_white | 722 | 3.8% |
| white | 589 | 3.1% |
| gray | 541 | 2.9% |
| oxford_white | 370 | 2.0% |
| bright_white_clearcoat | 352 | 1.9% |
| blue | 321 | 1.7% |
| silver | 303 | 1.6% |
| platinum_gray_metallic | 272 | 1.4% |
| carbonized_gray_metallic | 256 | 1.3% |
| Other values (1310) | 14124 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 29573 | |
| e | 29207 | 10.1% |
| a | 28108 | 9.8% |
| _ | 25657 | 8.9% |
| i | 23803 | 8.3% |
| t | 22639 | 7.9% |
| c | 18645 | 6.5% |
| r | 17494 | 6.1% |
| m | 11499 | 4.0% |
| b | 8074 | 2.8% |
| Other values (32) | 73449 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 288148 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 29573 | |
| e | 29207 | 10.1% |
| a | 28108 | 9.8% |
| _ | 25657 | 8.9% |
| i | 23803 | 8.3% |
| t | 22639 | 7.9% |
| c | 18645 | 6.5% |
| r | 17494 | 6.1% |
| m | 11499 | 4.0% |
| b | 8074 | 2.8% |
| Other values (32) | 73449 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 288148 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 29573 | |
| e | 29207 | 10.1% |
| a | 28108 | 9.8% |
| _ | 25657 | 8.9% |
| i | 23803 | 8.3% |
| t | 22639 | 7.9% |
| c | 18645 | 6.5% |
| r | 17494 | 6.1% |
| m | 11499 | 4.0% |
| b | 8074 | 2.8% |
| Other values (32) | 73449 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 288148 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 29573 | |
| e | 29207 | 10.1% |
| a | 28108 | 9.8% |
| _ | 25657 | 8.9% |
| i | 23803 | 8.3% |
| t | 22639 | 7.9% |
| c | 18645 | 6.5% |
| r | 17494 | 6.1% |
| m | 11499 | 4.0% |
| b | 8074 | 2.8% |
| Other values (32) | 73449 |
page_channel
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
| shopping |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 153104 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | shopping |
|---|---|
| 2nd row | shopping |
| 3rd row | shopping |
| 4th row | shopping |
| 5th row | shopping |
Common Values
| Value | Count | Frequency (%) |
| shopping | 19138 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| shopping | 19138 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 38276 | |
| s | 19138 | |
| h | 19138 | |
| o | 19138 | |
| i | 19138 | |
| n | 19138 | |
| g | 19138 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 38276 | |
| s | 19138 | |
| h | 19138 | |
| o | 19138 | |
| i | 19138 | |
| n | 19138 | |
| g | 19138 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 38276 | |
| s | 19138 | |
| h | 19138 | |
| o | 19138 | |
| i | 19138 | |
| n | 19138 | |
| g | 19138 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153104 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 38276 | |
| s | 19138 | |
| h | 19138 | |
| o | 19138 | |
| i | 19138 | |
| n | 19138 | |
| g | 19138 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Unnamed: 0 | msrp | year | canonical_mmty | model | local_zone | interior_color | aff_code | price | price_badge | trim | drivetrain | dealer_name | dealer_zip | mileage | make | bodystyle | cat | vin | canonical_mmt | fuel_type | stock_type | exterior_color | page_channel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 57215.0 | 2024 | Chevrolet:Blazer EV:RS:2024 | Blazer EV | NaN | Black | national | 54595.0 | NaN | RS | All-wheel Drive | Castle Rock Chevrolet GMC | 80104.0 | 0.0 | Chevrolet | SUV | ev_crossover_midsize | 3GNKDCRJ6RS227894 | Chevrolet:Blazer EV:RS | Electric | New | sterling_gray_metallic | shopping |
| 1 | 1 | 58845.0 | 2024 | RAM:ProMaster 2500:High Roof:2024 | ProMaster 2500 | NaN | Black | national | 52446.0 | NaN | High Roof | Front-wheel Drive | New Smyrna Chrysler Jeep Dodge RAM | 32168.0 | 0.0 | RAM | Cargo Van | van_fullsize | 3C6LRVDG0RE118763 | RAM:ProMaster 2500:High Roof | Gasoline | New | bright_white_clearcoat | shopping |
| 2 | 2 | 58795.0 | 2024 | Mercedes-Benz:Sprinter 2500:High Roof:2024 | Sprinter 2500 | NaN | NaN | national | 54295.0 | NaN | High Roof | Rear-wheel Drive | Mercedes-Benz of Farmington | 84025.0 | 8.0 | Mercedes-Benz | Cargo Van | van_fullsize | W1Y4KCHY8RT178723 | Mercedes-Benz:Sprinter 2500:High Roof | Diesel | New | blue_grey | shopping |
| 3 | 3 | 33815.0 | 2024 | Honda:CR-V:EX:2024 | CR-V | NaN | Gray | national | NaN | NaN | EX | Front-wheel Drive | Kingman Honda | 86409.0 | 7.0 | Honda | SUV | crossover_compact | 5J6RS3H44RL004214 | Honda:CR-V:EX | Gasoline | New | radiant_red_metallic | shopping |
| 4 | 4 | 27995.0 | 2024 | Chevrolet:Equinox:LS:2024 | Equinox | NaN | Medium Ash Gray | national | 24803.0 | NaN | LS | Front-wheel Drive | McSweeney Chevrolet GMC Clanton | 35045.0 | 0.0 | Chevrolet | SUV | crossover_midsize | 3GNAXHEG1RL299011 | Chevrolet:Equinox:LS | Gasoline | New | summit_white | shopping |
| 5 | 5 | 83630.0 | 2024 | Audi:Q8 e-tron:Premium:2024 | Q8 e-tron | NaN | Pearl Beige | national | 83630.0 | NaN | Premium | All-wheel Drive | Audi Stuart | 34997.0 | 20.0 | Audi | SUV | ev_crossover_midsize | WA15AAGE4RB021424 | Audi:Q8 e-tron:Premium | Electric | New | glacier_white_metallic | shopping |
| 6 | 6 | 33610.0 | 2024 | Mitsubishi:Eclipse Cross:SEL:2024 | Eclipse Cross | NaN | Gray | national | 33610.0 | NaN | SEL | Four-wheel Drive | McClinton Auto Group | 26101.0 | 5.0 | Mitsubishi | SUV | crossover_compact | JA4ATWAA2RZ046423 | Mitsubishi:Eclipse Cross:SEL | Gasoline | New | mercury_gray_metallic | shopping |
| 7 | 7 | 50185.0 | 2024 | Dodge:Hornet:R/T Plus:2024 | Hornet | NaN | Black | national | 40185.0 | NaN | R/T Plus | All-wheel Drive | Don Jackson CDJR North | 30028.0 | 16.0 | Dodge | SUV | hybrid_suv | ZACPDFDW9R3A24025 | Dodge:Hornet:R/T Plus | Hybrid | New | blue_steel | shopping |
| 8 | 8 | 27825.0 | 2024 | Nissan:Kicks:SR:2024 | Kicks | NaN | Charcoal | national | 27825.0 | NaN | SR | Front-wheel Drive | Halladay Nissan | 82001.0 | 6.0 | Nissan | SUV | crossover_compact | 3N1CP5DV6RL526633 | Nissan:Kicks:SR | Gasoline | New | scarlet_ember_tintcoat | shopping |
| 9 | 9 | 53727.0 | 2024 | Volkswagen:Atlas Cross Sport:2.0T SEL Premium R-Line:2024 | Atlas Cross Sport | NaN | Black w/ Blue Crust | national | 50727.0 | NaN | 2.0T SEL Premium R-Line | All-wheel Drive | AutoNation Volkswagen Las Vegas | 89146.0 | 10.0 | Volkswagen | SUV | suv_midsize | 1V2FE2CA0RC238064 | Volkswagen:Atlas Cross Sport:2.0T SEL Premium R-Line | Gasoline | New | platinum_gray_metallic | shopping |
| Unnamed: 0 | msrp | year | canonical_mmty | model | local_zone | interior_color | aff_code | price | price_badge | trim | drivetrain | dealer_name | dealer_zip | mileage | make | bodystyle | cat | vin | canonical_mmt | fuel_type | stock_type | exterior_color | page_channel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19128 | 19128 | 51410.0 | 2024 | Ford:Explorer:XLT:2024 | Explorer | NaN | Light Slate | national | 48350.0 | NaN | XLT | Four-wheel Drive | Webb Ford | 46322.0 | 10.0 | Ford | SUV | suv_midsize | 1FMSK8DH5RGA80767 | Ford:Explorer:XLT | Gasoline | New | rapid_red_metallic_tinted_clearcoat | shopping |
| 19129 | 19129 | 220250.0 | 2024 | Mercedes-Benz:Maybach GLS 600:4MATIC:2024 | Maybach GLS 600 | NaN | Crystal White | national | 220250.0 | NaN | 4MATIC | All-wheel Drive | Mercedes-Benz of Westmont | 60559.0 | 13.0 | Mercedes-Benz | SUV | luxurysuv_suv | 4JGFF8HB8RB190818 | Mercedes-Benz:Maybach GLS 600:4MATIC | Gasoline | New | cirrus_silver_metallic | shopping |
| 19130 | 19130 | 61395.0 | 2024 | Lincoln:Nautilus:Reserve:2024 | Nautilus | NaN | Black Onyx | national | 61395.0 | NaN | Reserve | All-wheel Drive | Fox Lincoln | 60647.0 | 2.0 | Lincoln | SUV | luxurysuv_crossover | 5LMPJ8K46RJ801932 | Lincoln:Nautilus:Reserve | Gasoline | New | infinite_black_metallic | shopping |
| 19131 | 19131 | 21480.0 | 2024 | Nissan:Versa:1.6 SV:2024 | Versa | NaN | Graphite | national | 21480.0 | NaN | 1.6 SV | Front-wheel Drive | Al Piemonte Nissan | 60160.0 | 10.0 | Nissan | Sedan | sedan_compact | 3N1CN8EV0RL880511 | Nissan:Versa:1.6 SV | Gasoline | New | gun_metallic | shopping |
| 19132 | 19132 | 146195.0 | 2024 | BMW:i7:xDrive60:2024 | i7 | NaN | Smoke | national | 146195.0 | NaN | xDrive60 | All-wheel Drive | BMW of Orland Park | 60467.0 | 8.0 | BMW | Sedan | ev_luxurypassenger_standard | WBY53EJ04RCS04853 | BMW:i7:xDrive60 | Electric | New | mineral_white_metallic | shopping |
| 19133 | 19133 | 0.0 | 2018 | BMW:X4:M40i:2018 | X4 | NaN | Black w/Gray Contrast Stitching | national | 29995.0 | NaN | M40i | All-wheel Drive | Chi Town Motors | 60445.0 | 48486.0 | BMW | SUV | luxurysuv_crossover | 5UXXW7C57J0Z44858 | BMW:X4:M40i | Gasoline | Used | alpine_white | shopping |
| 19134 | 19134 | 0.0 | 2021 | Mercedes-Benz:GLA 250:Base 4MATIC:2021 | GLA 250 | NaN | Black | national | 34750.0 | NaN | Base 4MATIC | All-wheel Drive | Loeber Motors Mercedes-Benz | 60712.0 | 16402.0 | Mercedes-Benz | SUV | luxurysuv_crossover | W1N4N4HB3MJ172323 | Mercedes-Benz:GLA 250:Base 4MATIC | Gasoline | Used | night_black | shopping |
| 19135 | 19135 | 21480.0 | 2024 | Nissan:Versa:1.6 SV:2024 | Versa | NaN | Graphite | national | 20943.0 | NaN | 1.6 SV | Front-wheel Drive | 94 Nissan Of South Holland | 60473.0 | 7.0 | Nissan | Sedan | sedan_compact | 3N1CN8EV3RL885198 | Nissan:Versa:1.6 SV | Gasoline | New | black | shopping |
| 19136 | 19136 | 53730.0 | 2024 | Nissan:Pathfinder:Platinum:2024 | Pathfinder | NaN | NaN | national | 53730.0 | NaN | Platinum | Four-wheel Drive | Napleton Nissan | 46375.0 | 1.0 | Nissan | SUV | suv_midsize | 5N1DR3DJ2RC265764 | Nissan:Pathfinder:Platinum | Gasoline | New | black | shopping |
| 19137 | 19137 | NaN | 2021 | Ford:Bronco Sport:Outer Banks:2021 | Bronco Sport | NaN | Ebony | national | 25399.0 | NaN | Outer Banks | Four-wheel Drive | Hawk Ford of Carol Stream | 60188.0 | 46144.0 | Ford | SUV | crossover_compact | 3FMCR9C68MRA85839 | Ford:Bronco Sport:Outer Banks | Gasoline | Used | blue | shopping |